Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
CustomerAccountID (FK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | CustomerAccount(LE_CTAC) |
CustomerAccountInvoiceID (FK) | A unique system assigned identifier for the CustomerAccountInvoice | ID_INVC_CTAC | Identity | integer | CustomerAccountInvoice(DO_INVC_CTAC) |
CustomerRepresentativeID (FK) | A customer assigned identifier for the Driver fueling the vehicle. | ID_CT_RPS | Identity | integer | CustomerAgent(PA_CT_RPS) |
CustomerAccountCardID (FK) | A 16 digit Credit or Debit card PAN as defined by ISO-7812, uniquely identifying CustomerAccountCard. | AI_ACNT_CT_CRD | CreditDebitCardPAN | varchar(20) | CustomerAccountCard(LE_ACNT_CT_CRD) |